-- Create table
create external table jms_ods.tab_channel_mapping_online
(
  channel_code string comment '订单来源编码'
  ,channel_name string comment '订单来源名称'
  ,channel_type string comment '订单一级分类'
)comment '散单来源配置表'
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/tab_channel_mapping_online'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
)
